THREADPOOL Component (THPL) Commands

DISPLAY

Shows a summary of the threadpool settings.

Parameters

SHOW=STAT

Shows a summary of the threadpool settings and a detailed overview of the threadpool statistics.

Example

THPL,DISPLAY displays a summary of the Service settings and the DataSource settings for each data source, as shown:

ServiceMinThreads(xxx),ServiceMaxThreads(yyy), 
ServiceThreadLockThreshold 
ServiceDB2MaxThreads(uuu),ServiceDB2MinThreads(ttt) 
DataSourceThreadMaxRpc(nnn),   
DataSourceThreadRpcTimeOut(nnn)  

THPL,DISPLAY,SHOW=STAT displays an overview of the threadpool statistics, as shown:

Threads    NrOfRPC              NrRPC            CPU            %CPU 
=======    =======              ========         ===            ===== 
TWORK003   number of RPC's      % of total RPC   CPU seconds    %of total CPU 
TWORK004   handled by this  
           workerthread 
... 
TWORKnnn   ... 

LIST

Lists the status of all sessions. The maximum number of lines of output for a single invocation of this operator command is 100. The ADDRESS and USERID arguments will further limit the requested output.

Parameters

ADDRESS=client Ipaddress

Identifies the client IP address.

USERID=userid

Identifies a userid.

Both the optional client Ipaddress and the userid parameters can be specified generically.

Example

THPL LIST lists the status of all sessions, up to a maximum of 100 sessions.

THPL LIST USERID=MFI* lists the status of the sessions with a userid prefixed with MFI.

THPL LIST ADDRESS=10.131.* lists the status of all sessions for which the client IP address begins with 10.131.

THPL LIST USERID=MFI*,ADDRESS=10.131.40.59 lists the status of all sessions for userids prefixed with MFI and that have a client IP address of 10.131.40.59.

KILL

Kills a session.

Parameters

ID=session_ID

Identifies the session that must be stopped. The SessionId can be obtained from the LIST command.

NOTE: This parameter is required.

Example

THPL KILL ID=2 stops session 2.